Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
StoredValueInstrumentID (PK) | A token ID for a StoredValueInstrument | ID_STRD_VL_INSTRMNT | Identity | integer | |
StoredValueInstrumentTypeCode (FK) | An ARTS standard code to designate the category of a StoredValueInstrument. POSLOG6 values are: GiftCard GiftCertificate PhoneCard SmartCard OnlineVoucher CarwashVoucher | CD_STRD_VL_INSTRMNT_TYP | Code | varchar(20) | StoredValueInstrumentType(CO_STRD_VL_INSTRMNT_TYP) |
StoredValueInstrumentStateCode | Indicates the current status of this StoreValueInstrument. Valid values based on POSLOG6 are: Active Inactive Expired Stolen Damaged | CD_STRD_VL_INSTRMNT_ST | Code | varchar(20) | |
ActivationDateTime | The date and time where this StoredValueInstrument is activated for use by a customer. | DT_ACV_DT_TM | DateTime | datetime | |
IdentificationTypeCode | The category of identification a customer must present to authenticate their right to purchase or redeem a StoredValueInstrument. There may be age restrictions governing the sale and redemption of gift cards. A drivers license, for example, may be used to verify a customer's age. NOTE: POSLOG6 has a separate element called PersonalIdentificationType that has an enumerated value list. Should we use that inplace of "IdentificationType"? POSLOG6 Valid values for PERSONAL IdentificationType are: AccountID DUNS GLN StoreID TaxID DriversLicense BusinessID MilitaryID Passport CreditCard NationalIdentityCard | CD_IDTN_TYP | Code | varchar(20) | |
Description | Short narrative description of the StoredValueInstrument | DE_DSCR | DescriptionShort | varchar(255) | |
SerialNumber | A unique identifying BUSINESS number assigned to the stored value instrument. | AI_SRL_NMB | Identity | integer | |
FaceValueAmount | The face value assigned to the StoredValueInstrument. For example a $25 gift card has a face value of $25. Its actual balance changes as it is used to purchase items or recharged (added to). | MO_FC_VL_AMT | Money | decimal(16,5) | |
UnspentAmount | The monetary value balance remaining on the StoredValueInstrument. | MO_UNSP_AMT | Money | decimal(16,5) | |
ExpirationDate | The date when the StoredValueInstrument is nolonger active. | DC_EP_DT | DateCalendar | date | |
CustomerAccountID (FK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerStoredValueAccount(LE_CT_STRD_VL_ACNT) |
VoucherInChangeAmount | The monetary value of the change that has been given as a voucher. | MO_VCHR_IN_CHN_AMT | Money | decimal(16,5) | |
Issuing (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL_ISSNG | Identity | integer | RetailStore(PA_STR_RTL) |
StatusCode | Code that indicates the current state of the StoredValueInstrument. Valid values: A = Active I = Inactive | CD_STS | Code2Status | char(2) | |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |